Hi there, we'll take this one step at a time!
If you struggle with a blank canvas, use this boilerplate to start. Remember, this is a flexible resource—tweak it as needed. Some sections might not apply to your product and you might come up with great ideas not listed here, don't let be restricted.
This is not the only format, we would love to see you scope out a great format for your product!
Go wild and dive deep—we love well-researched documents that cover all bases with depth and understanding.
Reminder to delete any unused boilerplate material before making your final submission
SQLNinja is a gamified, AI-assisted SQL learning platform. It understands the user's current competency level and career goals by asking questions in the beginning and creates a tailored path for learners to teach them exactly what they need to learn in order to go to the next level.
What is the fundamental need or want that the product is solving for?
Creating a personalized SQL learning path with the help of AI based on the user's career goals & competency levels.
What are the basic features and functionalities that the product provides?
The core features of the products are as follows:
Based on your career goal & Gradually build up SQL skills with step-by-step concepts, ensuring a smooth progression in difficulty.
Engage in conversational learning with AI-driven feedback, tailored to your understanding and needs.
Get a snapshot of your SQL concepts understanding based on historical performance
Solve challenges relevant to your role—like retention queries for product analysts or CAC queries for marketing analysts—enhancing practical application.
Receive personalized practice questions based on your past performance, reinforcing areas where you need improvement.
Start querying instantly without the need for any SQL server installation—just log in and practice.
Stay motivated with daily, weekly, and monthly leaderboards that track your progress against other learners.
Track your progress through streaks, points, and badges, helping you visualize your learning journey.
Build a daily SQL habit with challenges categorized as Easy, Medium, and Hard, designed to keep you engaged and improving.
Send appreciation pings to peers who solve challenges, fostering a supportive learning community.
Quickly revisit key concepts with refresher modules, perfect for when you need to brush up on specific topics
SQLNinja has a dedicated data newsletter - DataPulse Weekly
on Substack. It has about 600 subscribers & deliver a weekly engaging newsletter to help readers build a data-driven mindset and improve their decision making skills
The platform allows users to share their progress with their professional network, especially LinkedIn. The below image goes on LinkedIn with the links to the user profile that has more information about the user's past historical performance. Easy for any potential employer to find the users.
For instance -
1. Out of 12 users surveyed, they identified 8 different platforms they use to learn SQL, highlighting the fragmented landscape of SQL education. This diversity indicates that users are burdened with the task of sifting through multiple platforms to find one that meets their specific learning needs. This process can be time-consuming and overwhelming, leading to a less efficient and often frustrating learning experience.
2. One striking observation was the contrast between how users prefer to learn SQL and their actual go-to sources. While 50% of users indicated that 'Interactive Learning Platforms' are their first choice, 57% still rely on non-interactive platforms like YouTube, Coursera, and Udemy!
TL;DR - Helps user personalize their SQL learning with the help of AI for their career goals - saves time, removes guesswork & accelerates learning.
How exactly? - SQL can be divided and learned across various concepts aligned with specific career goals. Our platform maps each user’s career goal to the appropriate SQL concepts, creating a personalized learning path. This path is guided by AI, utilizing reinforcement learning and gamification to ensure the user progresses in the right direction. The two images below illustrate the different SQL concepts and how they are mapped to various roles.
Different SQL concepts -
SQL Concepts Category mapped with Career Goals -
Why the user will choose us over our competition?
While we are still in the pre-PMF stage, upon doing user research below are the reasons why the user will choose us over over our competitors:
Reason 1: Tailored Learning Paths, AI-guided learning
Customization of the learning path based on the user's career goal and competency level is a big differentiation & one of the most desirable features. "
Overwhelming abundance of SQL resources
" is one of the top challenges for the users. We take the guesswork out and outline the learning path for the user during their onboarding journey.
Reason 2: Progress tracking
One of the biggest differences is how we track the user's understanding of the concepts by looking at their historical performance. Current platforms are limited to how many questions the users have solved with Easy, Medium & Hard difficulties.
Reason 3: Gamification
While gamification was not one of the most sought-after features, this has never been tried in SQL learning. Duolingo has already proved that learning can be made fun by gamifying learning & this is another differentiation we would like to bet on.
Here are some intangible benefits that may be core value propositions for your customers:
Other points:
Journey Maps & Experience Mapping:
Create journey maps to visualize the user’s path from discovery to adoption, identifying key touchpoints and potential friction areas, this helps us to look at the process from a user point of view
Journey 1: Onboarding & realizing the core value proposition
The user learns about the platform from an existing user →
The user lands on the website →
The user is educated about the features & benefits →
Onboarding questionnaire to know the career goal of the user →
Based on the selection, the user is served with 10 multiple-choice questions to understand their current competency (The user has the option to skip & select the competency manually, not recommended though) →
A personalized learning path is created for the users based on responses →
The user needs to sign up →
Users have the option to either practice or learn →
The user starts solving the problem on the platform →
A real-time progress bar appears →
The user receives real-time feedback from an AI guide →
The user progresses in the journey to solve more problems →
AI guide changes the difficulties of the problems based on user performance →
The user gets excited about learning a new concept & feels accomplished
Journey 2: User engaging with the platform (Solving daily challenges)
The user receives an email for daily challenges with the current streak →
The user clicks on the email and login →
User solves the daily challenge →
The user receives points & progresses through the leaderboard →
Users feel motivated & accomplished
We have chosen the top 3 ICPs. There can be more ICPs.
Criteria | Final year college student - looking to get a job in the data analytics field | Analytics professional with 1-2 years of experience | Non-technical professional moving to the data analytics field with 1-2 years of experience |
---|---|---|---|
Name | Rashi | Sandeep | Rizwan |
Age | 19-24 | 20-26 | 23-30 |
Demographics |
|
|
|
Need | Get a job | Upskill | Transition to data jobs |
Pain Point | Low pocket money, | Go deep in core data skills, Unawareness of analytics career roadmap, | Low pay in the existing jobs, |
Solution | Learn a core data skill to become employable | Learn a core data skill in-depth | Learn a core data skill to transition to data jobs |
Behavior |
|
|
|
Perceived Value of Brand | NA as the product is in early PMF | NA as the product is in early PMF | NA as the product is in early PMF |
Marketing Pitch | Learn the most important data skills - SQL with an AI tutor | Learn advanced SQL and shine at your work with SQL AI tutor | Transition to a data career by learning the most important skills - SQL with an AI tutor |
Goals | Get a decent job in the salary range of 30-100k | Get a promotion | Transition to a data job for a better career prospectus |
Frequency of use case | Daily during job placements | 2-3 times a week (mostly during the weekend) | 2-3 times a week (mostly during the weekend) |
Average Spend on the Product | 1000 INR | 3000 INR | 3000 INR |
(build your ICP's- by now you know how to do that and then segment the users, think about why are you even segmenting and what is the goal of your product and segmentation)
(use this template and don't forget to add more parameters)
User Type | Casual | Core | Power |
---|---|---|---|
Usage Characteristics | Looking to upgrade their SQL skills | Have SQL as one of the core requirements to clear data interview | They have their hair on fire and looking to get into a job or change the careers to data |
Recency of use case | Last week | Last week | Last week |
Natural Frequency | 1-2 times a week | 3-5 times a week | Multiple times a day |
Monetary/AOV/Revenue Generated | 3000 INR per month | 3000 INR per month | 1000 INR per month |
Pain Points | Go deep in core data skills, Unawareness of analytics career roadmap, | Low pay in the existing jobs, | Low pocket money, |
Valued Features |
|
|
|
Core Value Proposition | Learn a core data skill in-depth | Learn a core data skill to transition to data jobs | Learn a core data skill to become employable |
JTBD of the persona | Primary - Personal, | Primary - Financial, | Primary - Financial, |
Discovery | Through Linkedin or existing users | Through Linkedin, Reddit or existing users | Through Linkedin, Reddit or existing users |
Level of Engagement | Solve only Hard platforms & stay active, find email journeys helpful, and Mostly track the habit. | Solve only Hard platform & stay active, find motivation to solve problem helpful and highly engaged with AI guide | Solve only Hard platform & stay active, Use all the features, Highly competitive |
define how is a user activated on your platform and who would classify as an active user. Then move one to defining your core EnR metric, don't forget to mention the why!
A user is considered an active user when they submit any SQL query on the platform. Submitting any SQL query shows user time investment. An activation could also be when a user finishes a personalized learning lesson or sends kudos to another user when they solve a problem.
The user logs into the system and goes through an onboarding journey that personalized their SQL learning. They get a hook.
The user logs in the the platform from their desktop and solves any daily challenges. Upon solving the problem the user gets a boost when they receive points and goes up in the ladder. They see another gamification element of the platform.
(also scope out the Engagement Framework you will be taking up for your product and the rationale behind it)
Engagement Framework | Relevance | Key Metric to be tracked | Rationale |
---|---|---|---|
Breadth | Primary/Secondary/Tertiary |
| All to these metrics shows different product features of the platform |
Depth | Primary/Secondary/Tertiary |
| These metrics show how deep the user is into each specific feature if the user solves all 3 daily challenge problems, it means that the user is trying to maximize their learning by solving all problems. |
Frequency | Primary/Secondary/Tertiary |
| Streak shows how many times the user has been active on the platform. This is a habit loop. 2,3 shows how frequently the user is utilizing the platform |
6. Metrics to track -
you need to build at least 5 separate engagement campaigns, yes 5 is important! Remember to bring the campaigns to life- give them structure and body.
(use this and add more depth/parameters in this framework)
Engagement Campaign | Hypothesis | Channel of Distribution | Persona/Type of User | Theme | Target feature | Pitch and Content | Goal of the campaign | Details | Offer | Frequency and Timing | Success Metrics | Milestones for the campaign |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Campaign 1 | Sending streak reminders to the most engaged users will keep them coming! | Users who solved a problem yesterday | Progress & Motivation | Daily Challenges, streak | Maintain your steak by solving today's challenge! | Get the users to solve an SQL problem every day | Subject - Keep Your 5-Day Streak Alive, Arjun! | Build the streak and don't lose their progress. Zero budget required. | Daily one email | # of users maintaining steak out of total activated users in the last month | 20% of the activated users maintained streak, | |
Campaign 2 | Celebrate user milestone! | Whatsapp/Email | Users who hit 7 days, 30 days, 60 days, 90 days streak | Motivation | Daily Challenges, streak | Congratulations! You did it. | Motivate and appreciate user's effort | Subject - Congrats, Arjun! You've Achieved a 7-Day Streak!
| Celebrate their milestones. Zero budget required. | On the basis of goal completion | % of users hitting milestones | 10% of activated users to cross 7 day streak, 20% of activated users to cross 7 days sterak, 30% of activated users to cross 7 days streak |
Campaign 3 | 30 Days Challenge! | Whatsapp/Email | Users who have completed 7 days of streak | Motivation | Daily Challenges, streak | Congratulations! You did it. | Increase users to go the next milestones | Subject: Next goal unlocked, Arjun! | Achieve key milestones. Zero budget required. | On the basis of goal completion | % of users hitting milestones compared to previous milestones | 10% of 7 days streak completed 14 days streak, 20% of 7 days streak completed 14 days streak, 10% of 14 days streak completed 30 days streak |
Campaign 5 | | |
The plan for the campaigns has been shared on the top in the google sheet screenshot.
figure out the retention data for your product. If you don't have access to the same, begin by adjusting the industry standards. Plot down the data and bring to life your retention curve. Draw out observations and insights from the same.
Below is the sample graph for the retention:
As per the data collected and observations, below the some of the core insights:
go back to your user insights and figure out the number one reason for churn by listing down all the factors
Most of the users churn because of these reasons:
1. Complexity of the daily challenges for freshers - Voluntary
Freshers get blockers when they face a new concept in the daily challenge. Having a concept link to the specific problem will help the users to resolve their issues.
you have already created the engagement campaigns, resurrection campaigns are quiet similar just keep in mind the churned users which are being targeted here.
(customized your campaigns as per the ICP you're targeting to bring back, add parameters accordingly)
Resurrection Campaign | Hypothesis | Channel of Distribution | Persona/Type of User | Theme | Target feature | Pitch and Content | Goal of the campaign | Details | Offer | Frequency and Timing | Success Metrics | Milestones for the campaign |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Campaign 1 | (what lead you to choosing this particular campaign and why do you think it will work?) | (Is is this a physical/digital campaign, how will the users come across this campaign) | (this section is extremely important for resurrection campaigns, who do you want to prioritize and why?) | (suggestion: connect the theme to the user calls) | | (are you trying to convert casual users to power users?) | (what are you giving and what is the logic behind the same, what could be the possible budget for the same?) | (when will you launch the campaign, is it a one time thing/recurring) | | (In case of products, where results will show after 9-12 months, what are the key milestone and what is the logic behind the same) | ||
Campaign 1 | Many users churned due to lack of progress. Offering new, personalized features will appeal to them. | Digital campaign via emails, in-app notifications, and social media ads. | Prioritize users with high initial engagement. They’ve shown interest and are more likely to return with the right incentives. | "Unlock Your SQL Potential" resonates with their goal of skill improvement and career advancement. | Percentile feature | Yes, by offering them a taste of premium features to deepen their engagement. | | Free month of premium, showing the value. Estimated budget: INR 5,0000 | Launch 2 weeks post-churn, recurring quarterly. | % of reactivated users | 1-month re-engagement, 3-month conversion, and quarterly retention checks. | |
Campaign 2 | Users left after achieving basics. Targeting with advanced content will re-engage them. | Digital via personalized emails and LinkedIn. | Prioritize advanced learners who want more challenging content. | "Advance Your Career with Advanced SQL Skills" ties to their desire for career growth. | SQL Advanced tips on email | Yes, focusing on turning interested learners into dedicated users with advanced features. | Free access to advanced courses, estimated budget: INR 30,000. | Quarterly launches to coincide with major product updates. | % of reactivated users | Monthly engagement with advanced content, track user progression. | ||
Campaign 3 | Some users churned due to pricing issues, offering discounts may bring them back. | Digital via emails and targeted ads. | Prioritize price-sensitive users who interacted with free content but didn’t convert. | "Affordable Learning for Everyone" appeals to users looking for value. | Yes, by providing affordable options to build long-term commitment. | 50% off annual subscription or extended trials, budget: INR 4,000. | Semi-annual launch. | % of reactivated users | Increase in subscription rates after discount offers. | |||
Campaign 4 | Users who prefer hands-on learning left; re-engage them with new interactive tools. | Digital via emails and in-app notifications. | Prioritize hands-on learners, as they are more likely to return with practical content. | "Learn by Doing" appeals to users who value practical learning. | Yes, aiming to deepen engagement through interactive tools. | Exclusive access to new interactive features, budget: INR 20,000. | Launch with new feature releases, and quarterly follow-ups. | % of reactivated users | Track usage of interactive features and completion of hands-on challenges. | |||
Campaign 5 | Users interested in certifications will return if we offer exclusive certification opportunities. | Digital via email, social media ads, and LinkedIn messages. | Prioritize users focused on career advancement through certifications. | "Get Certified, Get Ahead" appeals to users looking to validate their skills. | Yes, by providing certification paths to boost commitment. | Free certification exams or discounts, budget: INR 50,000. | Quarterly launches to coincide with product updates. | % of reactivated users | Track certifications completed and post-certification engagement. |
We hope this helped you break the cold start problem!
Reminder: This is not the only format to follow, feel free to edit it as you wish!
Reminder to delete any unused boilerplate material before making your final submission
Brand focused courses
Great brands aren't built on clicks. They're built on trust. Craft narratives that resonate, campaigns that stand out, and brands that last.
All courses
Master every lever of growth — from acquisition to retention, data to events. Pick a course, go deep, and apply it to your business right away.
Explore foundations by GrowthX
Built by Leaders From Amazon, CRED, Zepto, Hindustan Unilever, Flipkart, paytm & more
Crack a new job or a promotion with the Career Centre
Designed for mid-senior & leadership roles across growth, product, marketing, strategy & business
Learning Resources
Browse 500+ case studies, articles & resources the learning resources that you won't find on the internet.
Patience—you’re about to be impressed.